package com.showde.shoppingmall.db.constant;

public class ProductCategoryConstant {

	public static final String TABLENAME = "t_productcategory";

	public static final String PRODUCTCATEGORYID = "PRODUCTCATEGORYID";// 产品类别ID
	public static final String PRODUCTCATEGORYNAME = "PRODUCTCATEGORYNAME"; // 产品类别名称
	public static final String PRODUCTCATEGORYICONURL = "PRODUCTCATEGORYICONURL"; // 产品类别图标
	public static final String PRODUCTCATEGORYDESC = "PRODUCTCATEGORYDESC";// 产品类别简述
	public static final String PRODUCTCATEGORYPID = "PRODUCTCATEGORYPID";

	public static final int COLUMN_PRODUCTCATEGORYID = 1;// 产品类别ID
	public static final int COLUMN_PRODUCTCATEGORYNAME = 2; // 产品类别名称
	public static final int COLUMN_PRODUCTCATEGORYICONURL = 3; // 产品类别图标
	public static final int COLUMN_PRODUCTCATEGORYDESC = 4;// 产品类别简述
	public static final int COLUMN_PRODUCTCATEGORYPID = 5;

	public static final String[] dbColumns = new String[] { PRODUCTCATEGORYID,
			PRODUCTCATEGORYNAME, PRODUCTCATEGORYICONURL, PRODUCTCATEGORYDESC,
			PRODUCTCATEGORYPID };

	public static final String SQL_CREAT = "create table 't_productcategory' ("
			+ "_id int primary key,"
			+ "'PRODUCTCATEGORYID' varchar(20) not null unique,"
			+ "'PRODUCTCATEGORYNAME' varchar(30) not null,"
			+ "'PRODUCTCATEGORYICONURL' varchar(200) ,"
			+ "'PRODUCTCATEGORYDESC' varchar(200) ,"
			+ "'PRODUCTCATEGORYPID' varchar(20), "
			+ "FOREIGN KEY('PRODUCTCATEGORYPID') references 't_productcategory' ('PRODUCTCATEGORYID') ) ";
}